package com.hfzy.ihk.web.freeswitchManage.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hfzy.ihk.facade.freeswitchManage.entity.SimCard;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author czs
 * @since 2019-04-24
 */
public interface SimCardMapper extends BaseMapper<SimCard> {

    @Select("select num from sim_card")
    List<SimCard>  selectAll();

    @Update("update sim_card set state=#{state} where num=#{phone}")
    void updateState(@Param("phone")String phone, @Param("state")String state);


}
